Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 350378 |
| Missing cells | 53629 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.4 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | Constant |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with AANTAL_SUBTRAJECT_PER_SPC and 1 other fields | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 53629 (15.3%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.20565322) | Skewed |
Reproduction
| Analysis started | 2024-02-26 14:43:06.811509 |
|---|---|
| Analysis finished | 2024-02-26 14:43:26.242606 |
| Duration | 19.43 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1051134 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 350378 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 350378 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 350378 | |
| . | 350378 | |
| 0 | 350378 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 700756 | |
| Other Punctuation | 350378 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 350378 | |
| 0 | 350378 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 350378 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1051134 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 350378 | |
| . | 350378 | |
| 0 | 350378 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1051134 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 350378 | |
| . | 350378 | |
| 0 | 350378 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2024-02-06 00:00:00 |
|---|---|
| Maximum | 2024-02-06 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2024-02-01 00:00:00 |
|---|---|
| Maximum | 2024-02-01 00:00:00 |
Histogram with fixed size bins (bins=1)
JAAR
Date
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2024-01-01 00:00:00 |
Histogram with fixed size bins (bins=13)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 451.74501 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1041.6907 |
|---|---|
| Coefficient of variation (CV) | 2.3059263 |
| Kurtosis | 54.40075 |
| Mean | 451.74501 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.5052894 |
| Sum | 1.5828151 × 108 |
| Variance | 1085119.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 49275 | |
| 313 | 45475 | |
| 303 | 40309 | |
| 330 | 27550 | 7.9% |
| 316 | 23797 | 6.8% |
| 308 | 19099 | 5.5% |
| 306 | 14724 | 4.2% |
| 324 | 14418 | 4.1% |
| 301 | 13953 | 4.0% |
| 304 | 11361 | 3.2% |
| Other values (18) | 90417 |
| Value | Count | Frequency (%) |
| 301 | 13953 | 4.0% |
| 302 | 7693 | 2.2% |
| 303 | 40309 | |
| 304 | 11361 | 3.2% |
| 305 | 49275 | |
| 306 | 14724 | 4.2% |
| 307 | 6148 | 1.8% |
| 308 | 19099 | 5.5% |
| 310 | 3815 | 1.1% |
| 313 | 45475 |
| Value | Count | Frequency (%) |
| 8418 | 4695 | 1.3% |
| 8416 | 1186 | 0.3% |
| 1900 | 231 | 0.1% |
| 390 | 960 | 0.3% |
| 389 | 3673 | 1.0% |
| 362 | 4487 | 1.3% |
| 361 | 2551 | 0.7% |
| 335 | 3528 | 1.0% |
| 330 | 27550 | |
| 329 | 909 | 0.3% |
| Distinct | 1904 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3534982 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1174992 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 506 |
|---|---|
| 2nd row | 12 |
| 3rd row | 11 |
| 4th row | 11 |
| 5th row | 12 |
| Value | Count | Frequency (%) |
| 101 | 1496 | 0.4% |
| 402 | 1435 | 0.4% |
| 301 | 1406 | 0.4% |
| 403 | 1404 | 0.4% |
| 201 | 1333 | 0.4% |
| 203 | 1304 | 0.4% |
| 401 | 1170 | 0.3% |
| 404 | 1164 | 0.3% |
| 802 | 1137 | 0.3% |
| 409 | 1131 | 0.3% |
| Other values (1894) | 337398 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 224681 | |
| 0 | 215914 | |
| 2 | 155768 | |
| 3 | 127029 | |
| 5 | 90705 | |
| 9 | 84552 | 7.2% |
| 4 | 83109 | 7.1% |
| 7 | 69285 | 5.9% |
| 6 | 61403 | 5.2% |
| 8 | 50664 | 4.3% |
| Other values (15) | 11882 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1163110 | |
| Uppercase Letter | 11882 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 2205 | |
| M | 2008 | |
| B | 1433 | |
| Z | 1034 | |
| E | 1000 | |
| D | 784 | 6.6% |
| A | 772 | 6.5% |
| F | 733 | 6.2% |
| C | 391 | 3.3% |
| K | 381 | 3.2% |
| Other values (5) | 1141 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 224681 | |
| 0 | 215914 | |
| 2 | 155768 | |
| 3 | 127029 | |
| 5 | 90705 | |
| 9 | 84552 | 7.3% |
| 4 | 83109 | 7.1% |
| 7 | 69285 | 6.0% |
| 6 | 61403 | 5.3% |
| 8 | 50664 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1163110 | |
| Latin | 11882 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 2205 | |
| M | 2008 | |
| B | 1433 | |
| Z | 1034 | |
| E | 1000 | |
| D | 784 | 6.6% |
| A | 772 | 6.5% |
| F | 733 | 6.2% |
| C | 391 | 3.3% |
| K | 381 | 3.2% |
| Other values (5) | 1141 |
Common
| Value | Count | Frequency (%) |
| 1 | 224681 | |
| 0 | 215914 | |
| 2 | 155768 | |
| 3 | 127029 | |
| 5 | 90705 | |
| 9 | 84552 | 7.3% |
| 4 | 83109 | 7.1% |
| 7 | 69285 | 6.0% |
| 6 | 61403 | 5.3% |
| 8 | 50664 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1174992 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 224681 | |
| 0 | 215914 | |
| 2 | 155768 | |
| 3 | 127029 | |
| 5 | 90705 | |
| 9 | 84552 | 7.2% |
| 4 | 83109 | 7.1% |
| 7 | 69285 | 5.9% |
| 6 | 61403 | 5.2% |
| 8 | 50664 | 4.3% |
| Other values (15) | 11882 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6233 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4165927 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99899012 |
| median | 1.49899 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9010401 × 108 |
Descriptive statistics
| Standard deviation | 4.291256 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97162139 |
| Kurtosis | -1.741246 |
| Mean | 4.4165927 × 108 |
| Median Absolute Deviation (MAD) | 1.199 × 108 |
| Skewness | 0.46354923 |
| Sum | 1.5474769 × 1014 |
| Variance | 1.8414878 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2539 | 0.7% |
| 990004007 | 2500 | 0.7% |
| 990003004 | 2437 | 0.7% |
| 990004006 | 2047 | 0.6% |
| 990356076 | 1857 | 0.5% |
| 990356073 | 1730 | 0.5% |
| 131999228 | 1710 | 0.5% |
| 131999164 | 1685 | 0.5% |
| 990003007 | 1574 | 0.4% |
| 131999194 | 1539 | 0.4% |
| Other values (6223) | 330760 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 10501011 | 4 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 179 | |
| 998418080 | 163 | |
| 998418079 | 40 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 240 | |
| 998418073 | 241 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10613 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 520.77582 |
| Minimum | 1 |
|---|---|
| Maximum | 166129 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 105 |
| 95-th percentile | 1772 |
| Maximum | 166129 |
| Range | 166128 |
| Interquartile range (IQR) | 102 |
Descriptive statistics
| Standard deviation | 3206.8843 |
|---|---|
| Coefficient of variation (CV) | 6.1578979 |
| Kurtosis | 408.48179 |
| Mean | 520.77582 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 16.685963 |
| Sum | 1.8246839 × 108 |
| Variance | 10284107 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 57743 | 16.5% |
| 2 | 28177 | 8.0% |
| 3 | 18475 | 5.3% |
| 4 | 13508 | 3.9% |
| 5 | 10521 | 3.0% |
| 6 | 8934 | 2.5% |
| 7 | 7491 | 2.1% |
| 8 | 6286 | 1.8% |
| 9 | 5663 | 1.6% |
| 10 | 5113 | 1.5% |
| Other values (10603) | 188467 |
| Value | Count | Frequency (%) |
| 1 | 57743 | |
| 2 | 28177 | |
| 3 | 18475 | 5.3% |
| 4 | 13508 | 3.9% |
| 5 | 10521 | 3.0% |
| 6 | 8934 | 2.5% |
| 7 | 7491 | 2.1% |
| 8 | 6286 | 1.8% |
| 9 | 5663 | 1.6% |
| 10 | 5113 | 1.5% |
| Value | Count | Frequency (%) |
| 166129 | 1 | |
| 165184 | 1 | |
| 163737 | 1 | |
| 155869 | 1 | |
| 154640 | 1 | |
| 154258 | 1 | |
| 144714 | 1 | |
| 118396 | 1 | |
| 115934 | 1 | |
| 113287 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11468 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 617.67745 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 15 |
| Q3 | 115 |
| 95-th percentile | 2026 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 112 |
Descriptive statistics
| Standard deviation | 4143.4464 |
|---|---|
| Coefficient of variation (CV) | 6.708107 |
| Kurtosis | 713.24932 |
| Mean | 617.67745 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 21.205653 |
| Sum | 2.1642059 × 108 |
| Variance | 17168148 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55575 | 15.9% |
| 2 | 27673 | 7.9% |
| 3 | 18298 | 5.2% |
| 4 | 13297 | 3.8% |
| 5 | 10426 | 3.0% |
| 6 | 8919 | 2.5% |
| 7 | 7414 | 2.1% |
| 8 | 6216 | 1.8% |
| 9 | 5623 | 1.6% |
| 10 | 5094 | 1.5% |
| Other values (11458) | 191843 |
| Value | Count | Frequency (%) |
| 1 | 55575 | |
| 2 | 27673 | |
| 3 | 18298 | 5.2% |
| 4 | 13297 | 3.8% |
| 5 | 10426 | 3.0% |
| 6 | 8919 | 2.5% |
| 7 | 7414 | 2.1% |
| 8 | 6216 | 1.8% |
| 9 | 5623 | 1.6% |
| 10 | 5094 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231954 | 1 | |
| 230943 | 1 | |
| 227936 | 1 | |
| 227409 | 1 | |
| 226679 | 1 | |
| 223891 | 1 | |
| 218673 | 1 | |
| 215131 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9616 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7816.3831 |
| Minimum | 1 |
|---|---|
| Maximum | 237926 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 42 |
| Q1 | 414 |
| median | 1763 |
| Q3 | 6518 |
| 95-th percentile | 37209 |
| Maximum | 237926 |
| Range | 237925 |
| Interquartile range (IQR) | 6104 |
Descriptive statistics
| Standard deviation | 18045.087 |
|---|---|
| Coefficient of variation (CV) | 2.3086237 |
| Kurtosis | 34.337454 |
| Mean | 7816.3831 |
| Median Absolute Deviation (MAD) | 1605.5 |
| Skewness | 5.0605358 |
| Sum | 2.7386887 × 109 |
| Variance | 3.2562516 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 582 | 0.2% |
| 25 | 553 | 0.2% |
| 17 | 518 | 0.1% |
| 8 | 498 | 0.1% |
| 12 | 491 | 0.1% |
| 26 | 488 | 0.1% |
| 9 | 483 | 0.1% |
| 14 | 479 | 0.1% |
| 19 | 478 | 0.1% |
| 4 | 472 | 0.1% |
| Other values (9606) | 345336 |
| Value | Count | Frequency (%) |
| 1 | 385 | |
| 2 | 432 | |
| 3 | 422 | |
| 4 | 472 | |
| 5 | 430 | |
| 6 | 430 | |
| 7 | 452 | |
| 8 | 498 | |
| 9 | 483 | |
| 10 | 394 |
| Value | Count | Frequency (%) |
| 237926 | 22 | |
| 232873 | 23 | |
| 227997 | 23 | |
| 218547 | 24 | |
| 214503 | 17 | |
| 213515 | 25 | |
| 211576 | 17 | |
| 210414 | 19 | |
| 205337 | 17 | |
| 200599 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10672 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11348.518 |
| Minimum | 1 |
|---|---|
| Maximum | 370534 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 54 |
| Q1 | 553 |
| median | 2450 |
| Q3 | 9345 |
| 95-th percentile | 53283 |
| Maximum | 370534 |
| Range | 370533 |
| Interquartile range (IQR) | 8792 |
Descriptive statistics
| Standard deviation | 27099.947 |
|---|---|
| Coefficient of variation (CV) | 2.3879722 |
| Kurtosis | 37.728885 |
| Mean | 11348.518 |
| Median Absolute Deviation (MAD) | 2249 |
| Skewness | 5.297246 |
| Sum | 3.9762712 × 109 |
| Variance | 7.3440711 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 450 | 0.1% |
| 21 | 407 | 0.1% |
| 23 | 401 | 0.1% |
| 6 | 383 | 0.1% |
| 13 | 382 | 0.1% |
| 17 | 375 | 0.1% |
| 38 | 373 | 0.1% |
| 39 | 371 | 0.1% |
| 4 | 371 | 0.1% |
| 20 | 369 | 0.1% |
| Other values (10662) | 346496 |
| Value | Count | Frequency (%) |
| 1 | 291 | |
| 2 | 320 | |
| 3 | 345 | |
| 4 | 371 | |
| 5 | 349 | |
| 6 | 383 | |
| 7 | 338 | |
| 8 | 335 | |
| 9 | 301 | |
| 10 | 339 |
| Value | Count | Frequency (%) |
| 370534 | 22 | |
| 370296 | 23 | |
| 370137 | 23 | |
| 348482 | 25 | |
| 344911 | 24 | |
| 341651 | 19 | |
| 323753 | 20 | |
| 315768 | 17 | |
| 310748 | 17 | |
| 298625 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 328 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 678821.96 |
| Minimum | 1 |
|---|---|
| Maximum | 1487627 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 43684 |
| Q1 | 298229 |
| median | 753456 |
| Q3 | 1026244 |
| 95-th percentile | 1332263 |
| Maximum | 1487627 |
| Range | 1487626 |
| Interquartile range (IQR) | 728015 |
Descriptive statistics
| Standard deviation | 409874.74 |
|---|---|
| Coefficient of variation (CV) | 0.603803 |
| Kurtosis | -1.0837827 |
| Mean | 678821.96 |
| Median Absolute Deviation (MAD) | 307087 |
| Skewness | -0.027678339 |
| Sum | 2.3784428 × 1011 |
| Variance | 1.679973 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880922 | 5102 | 1.5% |
| 874080 | 4354 | 1.2% |
| 843976 | 4347 | 1.2% |
| 894296 | 4333 | 1.2% |
| 880450 | 4273 | 1.2% |
| 897686 | 4212 | 1.2% |
| 765004 | 4089 | 1.2% |
| 803748 | 4036 | 1.2% |
| 804298 | 4031 | 1.2% |
| 1059670 | 3914 | 1.1% |
| Other values (318) | 307687 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 16 | 3 | < 0.1% |
| 83 | 4 | < 0.1% |
| 1610 | 130 | |
| 1829 | 138 | |
| 1919 | 131 | |
| 2495 | 173 | |
| 2556 | 190 | |
| 4386 | 179 | |
| 5635 | 131 |
| Value | Count | Frequency (%) |
| 1487627 | 2975 | |
| 1450389 | 3048 | |
| 1421695 | 3564 | |
| 1344187 | 3543 | |
| 1340492 | 3441 | |
| 1332263 | 3545 | |
| 1316758 | 3401 | |
| 1316275 | 3463 | |
| 1282929 | 3576 | |
| 1268011 | 3351 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 328 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1103154.4 |
| Minimum | 1 |
|---|---|
| Maximum | 2668756 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 46632 |
| Q1 | 504900 |
| median | 1107060 |
| Q3 | 1810468 |
| 95-th percentile | 2593128 |
| Maximum | 2668756 |
| Range | 2668755 |
| Interquartile range (IQR) | 1305568 |
Descriptive statistics
| Standard deviation | 741410.45 |
|---|---|
| Coefficient of variation (CV) | 0.67208223 |
| Kurtosis | -0.75292098 |
| Mean | 1103154.4 |
| Median Absolute Deviation (MAD) | 620829 |
| Skewness | 0.35927552 |
| Sum | 3.8652102 × 1011 |
| Variance | 5.4968945 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211798 | 5102 | 1.5% |
| 1281474 | 4354 | 1.2% |
| 1216250 | 4347 | 1.2% |
| 1315553 | 4333 | 1.2% |
| 1300410 | 4273 | 1.2% |
| 1341797 | 4212 | 1.2% |
| 1155933 | 4089 | 1.2% |
| 1209711 | 4036 | 1.2% |
| 1207087 | 4031 | 1.2% |
| 2617416 | 3914 | 1.1% |
| Other values (318) | 307687 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 16 | 3 | < 0.1% |
| 142 | 4 | < 0.1% |
| 1861 | 130 | |
| 2097 | 138 | |
| 2194 | 131 | |
| 2816 | 173 | |
| 3325 | 190 | |
| 5261 | 179 | |
| 6291 | 131 |
| Value | Count | Frequency (%) |
| 2668756 | 3796 | |
| 2663844 | 3866 | |
| 2618309 | 3788 | |
| 2617416 | 3914 | |
| 2593128 | 3843 | |
| 2547840 | 3890 | |
| 2479678 | 3851 | |
| 2178334 | 3757 | |
| 2062010 | 3811 | |
| 2051882 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3693 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 53629 |
| Missing (%) | 15.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3629.5485 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 480 |
| median | 1270 |
| Q3 | 4210 |
| 95-th percentile | 13825 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3730 |
Descriptive statistics
| Standard deviation | 6561.8258 |
|---|---|
| Coefficient of variation (CV) | 1.8078904 |
| Kurtosis | 133.98854 |
| Mean | 3629.5485 |
| Median Absolute Deviation (MAD) | 1040 |
| Skewness | 6.8956274 |
| Sum | 1.0770649 × 109 |
| Variance | 43057558 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2090 | 0.6% |
| 105 | 1982 | 0.6% |
| 110 | 1792 | 0.5% |
| 180 | 1626 | 0.5% |
| 185 | 1571 | 0.4% |
| 140 | 1548 | 0.4% |
| 125 | 1466 | 0.4% |
| 175 | 1433 | 0.4% |
| 300 | 1427 | 0.4% |
| 165 | 1381 | 0.4% |
| Other values (3683) | 280433 | |
| (Missing) | 53629 | 15.3% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 670 | 0.2% |
| 95 | 716 | 0.2% |
| 100 | 1025 | |
| 105 | 1982 | |
| 110 | 1792 | |
| 115 | 1176 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99580 | 5 |
| AANTAL_PAT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_SUBTRAJECT_PER_SPC | AANTAL_SUBTRAJECT_PER_ZPD | BEHANDELEND_SPECIALISME_CD | GEMIDDELDE_VERKOOPPRIJS | ZORGPRODUCT_CD | |
|---|---|---|---|---|---|---|---|---|---|
| AANTAL_PAT_PER_DIAG | 1.000 | 0.317 | 0.321 | 0.987 | 0.298 | 0.318 | -0.061 | 0.028 | -0.179 |
| AANTAL_PAT_PER_SPC | 0.317 | 1.000 | 0.070 | 0.331 | 0.960 | 0.073 | -0.551 | -0.013 | -0.380 |
| AANTAL_PAT_PER_ZPD | 0.321 | 0.070 | 1.000 | 0.320 | 0.079 | 0.996 | 0.008 | -0.303 | -0.140 |
| AANTAL_SUBTRAJECT_PER_DIAG | 0.987 | 0.331 | 0.320 | 1.000 | 0.329 | 0.320 | -0.055 | 0.036 | -0.211 |
| AANTAL_SUBTRAJECT_PER_SPC | 0.298 | 0.960 | 0.079 | 0.329 | 1.000 | 0.086 | -0.470 | -0.015 | -0.408 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.318 | 0.073 | 0.996 | 0.320 | 0.086 | 1.000 | 0.013 | -0.306 | -0.149 |
| BEHANDELEND_SPECIALISME_CD | -0.061 | -0.551 | 0.008 | -0.055 | -0.470 | 0.013 | 1.000 | 0.046 | 0.214 |
| GEMIDDELDE_VERKOOPPRIJS | 0.028 | -0.013 | -0.303 | 0.036 | -0.015 | -0.306 | 0.046 | 1.000 | 0.029 |
| ZORGPRODUCT_CD | -0.179 | -0.380 | -0.140 | -0.211 | -0.408 | -0.149 | 0.214 | 0.029 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2024-02-06 | 2024-02-01 | 2024-01-01 | 8418 | 506 | 998418070 | 1 | 1 | 1 | 1 | 1 | 1 | NaN |
| 1 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 12 | 991900018 | 3649 | 4042 | 17753 | 22861 | 79304 | 103931 | 440.0 |
| 2 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 11 | 991900022 | 12597 | 13886 | 61915 | 80340 | 79304 | 103931 | 825.0 |
| 3 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 11 | 991900003 | 2 | 2 | 61915 | 80340 | 79304 | 103931 | 475.0 |
| 4 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 12 | 991900008 | 2581 | 2655 | 17753 | 22861 | 79304 | 103931 | 460.0 |
| 5 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 13 | 991900026 | 2 | 3 | 721 | 730 | 79304 | 103931 | 115.0 |
| 6 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 11 | 991900024 | 3801 | 4066 | 61915 | 80340 | 79304 | 103931 | 305.0 |
| 7 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 11 | 991900026 | 12795 | 13710 | 61915 | 80340 | 79304 | 103931 | 115.0 |
| 8 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 12 | 991900014 | 3094 | 3109 | 17753 | 22861 | 79304 | 103931 | 2085.0 |
| 9 | 1.0 | 2024-02-06 | 2024-02-01 | 2019-01-01 | 1900 | 11 | 991900025 | 40878 | 47362 | 61915 | 80340 | 79304 | 103931 | 290.0 |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 350368 | 1.0 | 2024-02-06 | 2024-02-01 | 2016-01-01 | 307 | B17 | 159899010 | 4 | 4 | 27 | 30 | 701312 | 1185601 | 4125.0 |
| 350369 | 1.0 | 2024-02-06 | 2024-02-01 | 2020-01-01 | 313 | 629 | 29099036 | 3 | 5 | 194 | 352 | 1046841 | 2618309 | 1110.0 |
| 350370 | 1.0 | 2024-02-06 | 2024-02-01 | 2014-01-01 | 303 | 211 | 199299058 | 3 | 3 | 9632 | 11143 | 1421695 | 1845592 | 4700.0 |
| 350371 | 1.0 | 2024-02-06 | 2024-02-01 | 2020-01-01 | 313 | 522 | 131999021 | 6 | 6 | 1482 | 3069 | 1046841 | 2618309 | NaN |
| 350372 | 1.0 | 2024-02-06 | 2024-02-01 | 2016-01-01 | 307 | B14 | 159899004 | 2 | 2 | 828 | 879 | 701312 | 1185601 | 10285.0 |
| 350373 | 1.0 | 2024-02-06 | 2024-02-01 | 2014-01-01 | 303 | 280 | 199299089 | 2 | 2 | 83903 | 87747 | 1421695 | 1845592 | 3570.0 |
| 350374 | 1.0 | 2024-02-06 | 2024-02-01 | 2020-01-01 | 313 | 932 | 119499056 | 1 | 1 | 2338 | 2927 | 1046841 | 2618309 | NaN |
| 350375 | 1.0 | 2024-02-06 | 2024-02-01 | 2020-01-01 | 313 | 094 | 990035002 | 1 | 1 | 134 | 140 | 1046841 | 2618309 | 275.0 |
| 350376 | 1.0 | 2024-02-06 | 2024-02-01 | 2013-01-01 | 326 | G4 | 990026017 | 1 | 1 | 1 | 1 | 22299 | 26173 | 490.0 |
| 350377 | 1.0 | 2024-02-06 | 2024-02-01 | 2020-01-01 | 313 | 924 | 119499072 | 1 | 1 | 1073 | 1222 | 1046841 | 2618309 | 22290.0 |